InventoryLocation

Entity Definition

Logical Name : InventoryLocation
Physical Name : LO_LCN_INV

A physical place the retailer stores merchandise. It may be co-located at a Site with RetailStore, DistributionCenter, or AdministrativeCenter. It does not include containers, ships and trucks that are in transit.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
LocationID (FK)(PK) A unique system assigned identifier for the Location. ID_LCN Identity integer
FunctionCode A code that describes what business activities and functions are performed in a specific location. Activities may include: ADMIN - Administration functions (no stock or customer services are handled here) DISPLY - Merchandise display (stock is presented to the customer for sale) CUSTSVC - Customer service - Customer merchandise may be picked up, returned, etc. RETADJ - Returns and adjustments - where a customer may return merchandise for a credit or refund. Where customers may request price adjustments (e.g. when they bought a sale item just before it went on special) STOCKPT - Stock Point - Out of customer sight location where merchandise is stored, counted and tracked at a physical and financial level. This could be the "back room" (like you see in shoe stores) or it could be a receiving dock, etc. RECV - Receiving or merchandise intake location where merchandise is physically unloaded and accepted by the retail store into its inventory (or at least acknowledged). And lots more depending on the retailer. These codes should indicate which locations involve merchandise sales and tracking. Based on the examples above DISPLY, STOCKPT, CUSTSVC, RECV and RETADJ all represent types of locations that involve the storage, sale or return of merchandise. There are many additional functions and codes that might be assigned depending on the retailer. As Internet sales open up, the concept of location changes. Instead of physical locations, merchandise tracking may be by URL and HTML name. The goal is still to understand WHERE merchandise is moving and where the ownership gets transferred from one party to another. CD_LCN_FNC Code6 char(6)
SecurityClassCode Defines the level of security required for a specific location. This is to accommodate secured merchandise like prescription drugs, guns and ammunition, upper end sound and video equipment, etc. CD_LCN_SCTY_CLS Code6 char(6)

Relationships

Parent Entity Verb Phrase Child Entity
InventoryLocation is specified by ICDMerchandiseLineItem
InventoryLocation is destination for InventoryAdjustmentLineItem
InventoryLocation acts on FulfillmentAcknowledgementLineItem
InventoryLocation is source for InventoryAdjustmentLineItem
InventoryLocation holds ItemInventory
InventoryLocation is a Tank
InventoryLocation is described by InventoryLocationEnvironmentClass
InventoryLocation stores fuel for Blender
InventoryLocation is intended dispatcher/pickup location for CustomerOrderProductGroup
InventoryLocation is location for PhysicalCountLineItem
InventoryLocation is destination for ReturnLineItem
InventoryLocation accepted TestDelivery
InventoryLocation is source for CustomerOrderShipment
Location can be a InventoryLocation

Logical Views containing InventoryLocation

Logical View
Logical 01010 - Item Description - Subtype View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02010 - Item Inventory - Adjustments View
Logical 02020 - Item Inventory - Selling View
Logical 02100 - Item Inventory - Macro View
Logical 02110 - Item Inventory - Location View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02316 - Distributed Order Management View
Logical 02340 - Retail Transaction - Shipping View
Logical 02600 - Inventory Control Transaction View
Logical 03300 - Reporting - Stock Ledger View
Logical 06320 - Party - Address and Contact View
Logical 07600 - Customer Order - Macro View
Logical 07610 - Customer Order - Maintenance View
Logical 07620 - Customer Order - Inventory Control View
Logical 10100 - Enterprise - Locations Macro View
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View
Logical 10110 - Enterprise - Location Retailer Organization View
Logical 10120 - Enterprise - Location, WkStn, Operator, Till
Logical 10200 - Enterprise - Merchandise View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20050 - Forecourt Tank Gauge View